To start working with databases in Navicat you are to establish the connection (see Connection Settings).
Attach Database
To attach a database
- Double-click the connection to open in the navigation pane.
- Control-click the opened connection and choose Attach Database.
- Fill in the required information:
Database Name
Enter the database name which displays in Navicat.
Database File
Set the file path for a database.Encrypted
Enable this option and provide Password when connecting to an encrypted SQLite database.
Open Database
To open a database which shows in the navigation pane
- Double-click the database to open in the navigation pane.
or - Control-click the database and choose Open Database.
Detach Database
To detach a database
- Control-click the database in the navigation pane and choose Detach Database.
Encrypt Database
To encrypt a database
- Control-click the database in the navigation pane and choose Encrypt Database.
- Enter the password.
Decrypt Database
To decrypt a database
- Control-click the database in the navigation pane and choose Decrypt Database.
- Confirm decrypting in the dialog window.
Close Database
To close a database
- Control-click the database in the navigation pane and choose Close Database.